create external table jms_dm.dm_door_sign_rate_export_dt 
(
date_time timestamp COMMENT '' ,
agent_code string COMMENT '' ,
agent_name string COMMENT '' ,
code string COMMENT '' ,
name string COMMENT '' ,
business_name string COMMENT '' ,
ordersource_flg  string COMMENT '订单来源' ,
cnt string COMMENT '' )
comment 'insert overwrite table jms_dm.dm_door_sign_rate_export_dt partition ( dt )'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_door_sign_rate_export_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
